﻿CREATE TABLE [dbo].[BillOrderAddress]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
	[BillOrderId] INT NOT NULL, 
    [ItemType] NVARCHAR(50) NULL, 
    [ExamId] NVARCHAR(50) NULL, 
    [Location] NVARCHAR(50) NULL, 
    [FetchTime] NVARCHAR(50) NULL, 
    [RcptNo] NVARCHAR(50) NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键，自增长',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderAddress',
    @level2type = N'COLUMN',
    @level2name = N'Id'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'检查/检验项目，C-检验，D-检查',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderAddress',
    @level2type = N'COLUMN',
    @level2name = N'ItemType'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'检查/检验单编号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderAddress',
    @level2type = N'COLUMN',
    @level2name = N'ExamId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'检查/检验位置',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderAddress',
    @level2type = N'COLUMN',
    @level2name = N'Location'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'取单时间',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderAddress',
    @level2type = N'COLUMN',
    @level2name = N'FetchTime'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'缴费订单Id',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderAddress',
    @level2type = N'COLUMN',
    @level2name = N'BillOrderId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'收据号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderAddress',
    @level2type = N'COLUMN',
    @level2name = N'RcptNo'